from sqlalchemy import create_engine

host='127.0.0.1'
port="5000"
database='test'
username='root'
password=''

DB_URI='mysql+pymysql://root@127.0.0.1:3306/test?charset=utf8'

engine=create_engine(DB_URI)

conn=engine.connect()

result=conn.execute('select 1')

print(result.fetchone())

